package com.oba.king.datalib.deliverytype;

import com.oba.base.dao.BaseDao;
import com.oba.base.interfaces.IHsqlBuilder;

public class DeliveryTypeDao extends BaseDao{
	
	public IHsqlBuilder findAll(){
		return getSqlBuilder("from DeliveryType dt order by dt.deliveryTypeName");
	}
	
	
	public IHsqlBuilder findByDeliveryName(String name){
		IHsqlBuilder sql =getSqlBuilder("from DeliveryType dt");
		sql.add("dt.deliveryTypeName like ?",name,"%","%");
		sql.addend("order by dt.deliveryTypeName");
		return sql; 
	}

}
